IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[cms_sp_SiteSave]') AND type in (N'P', N'PC'))
	DROP PROCEDURE [dbo].[cms_sp_SiteSave]
GO
create procedure [dbo].[cms_sp_SiteSave]
@Id int,
@SiteGroupId int,
@SiteName nvarchar(150),
@CreatedBy int,
@DateCreated datetime,
@LastUpdatedBy int,
@DateLastUpdated datetime
as
update dbo.Sites
set SiteGroupId = @SiteGroupId,
	SiteName = @SiteName,
	LastUpdatedBy = @LastUpdatedBy,
	DateLastUpdated = @DateLastUpdated
where SiteId = @Id


GO

